This used to be a two step process where you were required to issue an ALTER DATABASE PARTITION GROUP statement to add or drop the partitions first. 这在过去是由两个步骤组成的一个过程,首先需要发出ALTERDATABASEPARTITIONGROUP语句来添加或删除分区。
Some are related to performance and scalability, such as data row compression, and some are related to manageability, such as the ability to copy database schema, and ALTER TABLE statement enhancements. 其中一些特性与性能和可伸缩性有关,例如数据行压缩,而另外一些则与可管理性有关,例如复制数据库模式的功能,以及ALTERTABLE语句增强。
New syntax for disabling an index for foreign key constraint was added to use with the ALTER statement. 用于为外键约束禁用索引的新语句被使用ALTER语句添加来使用。
With the ALTER NICKNAME statement, you have the option to change the column data type on the federated server for a remote object. 通过ALTERNICKNAME语句,您可以选择为远程对象更改联邦服务器上的列数据类型。
Use the LOCKSIZE parameter of the ALTER TABLE statement to control how locking is done for a specific table on a permanent basis. 使用altERTABLE语句的LOCKSIZE参数控制如何在持久基础上对某个特定表进行锁定。
Note: A reorganization of the tables is necessary, the ALTER TABLE statement just updates the catalog content. 注意:表的重组是必需的,ALTERTABLE语句只是更新编目的内容。
As you want to execute the following statements against the target database MYSAMPLE, you alter the CONNECT statement accordingly. 因为希望对目标数据库MYSAMPLE执行下面的语句,所以要相应地修改CONNECT语句。
Note: All other types of alter operations can be executed directly against a replication table using a SQL ALTER statement. 注意:通过使用SQLalter语句,可以直接对复制表执行所有其他类型的alter操作。
The statements at B and C show only the col1 column because the ALTER TABLE statement has been rolled back. 标签B和C的语句仅显示col1列,因为ALTERTABLE语句被回滚了。
This can be added to existing tables using the ALTER TABLE statement, or the row change timestamp column can defined when creating a new table. 这可以通过ALTERTABLE语句添加到现有表,或者在创建新表时定义行修改时间戳列。
The ALTER COLUMN SET DATA TYPE option on the ALTER TABLE statement has been extended to support all compatible types. ALTERTABLE语句中的ALTERCOLUMNSETDATATYPE选项进行了扩展,可以支持所有兼容的类型。
The IMPLICITLY HIDDEN attribute on a CREATE or ALTER TABLE statement specifies that the column is not visible in SQL statements unless the column is explicitly referenced by name. CREATE或ALTERTABLE语句中的IMPLICITLYHIDDEN属性表示,除非根据名称显式引用列,否则该列在SQL语句中不可见。
The ALTER statement changes the transfer point specified in the GO TO statement. ALTER语句修改了GOTO语句中指定的转移点(transferpoint)。
At this point, if the impact on the application and database packages is acceptable, you or the DBA can execute the ALTER statement. 此时,如果对应用程序或数据库包的影响可以接受,那么您或那位DBA就可以执行ALTER语句。
So, if you wanted to attach a base table named Q4_2010_SALES to an existing partitioned table named SALES as a new partition, you could do so by executing an ALTER TABLE statement that looks like this 因此,如果您想将一个名为Q42010SALES的基表作为新分区添加到一个名为SALES的现有分区表,可以执行一个如下所示的ALTERTABLE语句
In combination with enhancements to the ALTER TABLE statement, a convenient way for managing different versions of a database solution was created. 再结合使用对ALTERTABLE语句的改进,就可以方便地管理数据库解决方案的不同版本。
Using the grid, you just need to execute the alter table SQL statement on the server where you have enabled the grid. 使用网格,您只需在启用了网格的服务器上执行SQL命令altertable。
You are advised to issue the ALTER DATABASE PARTITION GROUP statement to customize the tablespace setting and to control the container layout in the new partition. 建议发出ALTERDATABASEPARTITIONGROUP语句来定制表空间设置,并控制新分区中的容器布局。
A new, empty partition can be added to a partitioned table by executing the ALTER TABLE statement with the ADD PARTITION option specified; the syntax used looks like this 可以通过执行ALTERTABLE语句并指定ADDPARTITION选项来向一个分区表增加一个新的空分区,使用的语法如下所示
The ALTER BUFFERPOOL statement with the IMMEDIATE option takes effect right away, unless there is not enough reserved space in the database-shared memory to allocate new space. 只要数据库共享的内存中有足够的保留空间可以分配给新空间,带有IMMEDIATE选项的ALTERBUFFERPOOL语句会立刻生效。
The obsolete ALTER statement provides the same function as EVALUATE. 已被废弃的ALTER语句提供了与EVALUATE相同的功能。
Columns can be renamed online using the ALTER TABLE statement. 使用ALTERTABLE语句在线重命名列。
Thus, if you wanted to add an empty partition to a partitioned table named SALES, you could do so by executing an ALTER TABLE statement similar to this 这样,如果您想添加一个分区表名为SALES的空分区,可以执行一个与下面类似的ALTERTABLE语句
You can change its settings by running ALTER SEQUENCE statement any time when it is necessary. 必要时候,可以通过运行ALTERSEQUENCE语句更改其设置。
Note, however, that the ALTER TABLE statement only allows you to increase the inline length. 但是要注意,ALTERTABLE语句只允许增加inlinelength。
A common problem in such scripts is that the first time they are run, a create statement must be executed, but subsequent times an alter statement must be executed. 这类脚本中的一个共同问题是:当这些脚本在第一次运行时,必须执行一个create语句,以后运行时必须执行alter语句。
The function is modified by using the alter statement with the schemabinding option not specified. 在未指定schemabinding选项的情况下,使用alter语句修改函数。
Date the object was last modified by using an alter statement. 上次使用alter语句修改对象的日期。
The result is more substantive discussion of the immediate policy decision and greater willingness to alter the draft statement circulated before the meetings begin. 其结果是,在会上能够对即将出台的政策决定进行更实质性的讨论,也更愿意对会议开始前传阅的声明草案进行修改。
That the court notifies the parties concerned to alter the claims, which shall belong to judges 'right to make statement, further exceeds the traditional limitation of right to make statement. 法院告知当事人变更诉讼请求属于法官释明权,但已突破了传统释明权的范围。